package cn.tedu.boot04.controller;

import cn.tedu.boot04.entity.Product;
import cn.tedu.boot04.mapper.ProductMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * @author 作者：HeShaoShuai
 * @Email 邮箱：2569819541@qq.com
 * @Date 日期：2023/5/11 16:03
 * @Package 包名：cn.tedu.boot04.controller
 * @Project 项目名：JavaSE
 * @Version 1.0
 */
@RestController
public class ProductController {
	@Autowired
	ProductMapper mapper;
	@RequestMapping("/insert")
	public String insert(Product product){
		System.out.println("product="+product);
		mapper.insert(product);
		return "添加完成!<a href='/'>返回首页</a>";
	}
	@RequestMapping("/select")
	public String select(){
		List<Product> list = mapper.select();
		//把list集合中的数据装进表格标签
		String html = "<table border='1'>";
		html += "<caption>商品列表</caption>";
		html += "<tr><th>id</th><th>标题</th><th>价格</th><th>库存</th><th>操作</th></tr>";
		for (Product p : list) {
			html += "<tr>";
			html += "<td>" + p.getId() + "</td>";
			html += "<td>" + p.getTitle() + "</td>";
			html += "<td>" + p.getPrice() + "</td>";
			html += "<td>" + p.getNum() + "</td>";
			html += "<td><a href='/delete?id=" + p.getId() + "'>删除</a></td>";
			html += "</tr>";
		}
		html += "</table>";
		return html;
	}

	@RequestMapping("/delete")
	public String delete(int id){
		mapper.deleteById(id);
		return "删除完成!<a href='/select'>返回列表页面</a>";
	}
	@RequestMapping("/update")
	public String update(Product product){
		mapper.update(product);
		return "修改完成!<a href='/select'>返回列表页面</a>";
	}

}